﻿CREATE TABLE [dbo].[tc_website_sync]
(
    [id] UNIQUEIDENTIFIER NOT NULL, 
    [type] TINYINT NOT NULL,
    [status] TINYINT NOT NULL,
    [time] DATETIMEOFFSET NOT NULL,
    [created] DATETIMEOFFSET NOT NULL, 
    [created_by] NVARCHAR(64) NOT NULL, 
    [modified] DATETIMEOFFSET NOT NULL, 
    [modified_by] NVARCHAR(64) NOT NULL, 
    [row_version] TIMESTAMP NOT NULL, 
    CONSTRAINT [pk_tc_website_sync] PRIMARY KEY NONCLUSTERED ([id])
)

GO

CREATE CLUSTERED INDEX [ix_tc_website_sync_type_time] ON [dbo].[tc_website_sync] ([type], [time])
